Click the report.
If you have multiple page fields, arrange them in rows or columns.
Decide whether to make the layout changes onscreen or in the wizard. Usually you can make changes on the worksheet. If changes result in long delays to retrieve and display data, use the wizard.
If you can work onscreen, do one or more of the following:
Change the layout on the worksheet
Fields with icons in the PivotTable Field List window can be used only in the row, column, and page areas. Fields with icons can be used only in the data area. Fields with icons can be used in any area.
If the page area is missing (row or column fields start in row 1), use the wizard to change the layout and create page fields.
You can also click a data field and then point to the bottom border of the cell. When the pointer becomes an arrow, drag the data field to a new position.
Add or remove a field on the worksheet
Add a field Drag the field from the PivotTable Field List window to the area of the report for the type of field that you want to create.
Fields with icons in the PivotTable Field List window can be used only in the row, column, and page areas. Fields with icons can be used only in the data area. Fields with icons can be used in any area.
Remove a field Drag the field button out of the report.
If you can't work onscreen:
Use the wizard to change layout and add and remove fields
Some fields can only be used in some of the areas. If you drop a field in an area where it can't be used, the field won't appear in the area.
Notes
Format Report can also affect the layout of the report.
Changing the layout of a PivotTable report also affects any PivotChart reports that are based on the report, and some chart formatting may be lost.